﻿using models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace DAL
{
    public class ProductCountService
    {
        // 商品组合类型
        //新增商品组合类型
        public bool AddProductCount(ProductCount product) 
        {
            /// <summary>
            /// 新增商品组合类型
            /// </summary>
            string sql = string.Format("insert ProductCount values('{0}')", product.ProcountName);
            return DBhelper.ex(sql);
        }
        //查询所有商品组合类型
        public SqlDataReader SumProductCount() 
        {
            string sql = string.Format("select*from ProductCount");
            return DBhelper.DataReader(sql);
        }
    }
}
